<?php

$config['server_net'] = array(0=>'双线', 1=>'电信', 2=>'网通');
$config['server_status'] = array(0=>'新服', 1=>'推荐', 2=>'流畅', 3=>'维护', 4=>'内部测试', 5=>'普通', 6=>'即将开启');
$config['server_enabled'] = array(0=>'禁止', 1=>'禁用充值', 2=>'开启');
$config['is_iframe'] = array(0=>'禁止', 1=>'开启');
$config['is_active'] = array(0=>'禁止', 1=>'开启');
$config['is_commend'] = array(0=>'禁止', 1=>'开启');
$config['is_pk'] = array(0=>'禁止野外PK', 1=>'允许野外PK');
$config['country_type'] = array(2=>'中文', 1=>'英文');

// 服务区用户分表结构
$config['create_server_sql'] = "CREATE TABLE `g5_server_members_{game_id}_{server_no}` (
  `s_uid` int(11) unsigned NOT NULL auto_increment COMMENT '服务区用户编号',
  `user_id` int(11) unsigned NOT NULL COMMENT '会员编号',
  `user_code` varchar(50) NOT NULL COMMENT '会员名',
  `user_status` tinyint(1) NOT NULL default '0' COMMENT '会员游戏状态',
  `user_channel` int(11) unsigned NOT NULL default '0' COMMENT '推广渠道',
  `user_from` int(11) unsigned NOT NULL default '0' COMMENT '海报编号',
  `user_from_site` varchar(64) NOT NULL COMMENT '分站标识',
  `user_add_date` int(10) unsigned NOT NULL default '0' COMMENT '注册时间',
  `user_game_role` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL COMMENT '游戏角色',
  `user_game_level` tinyint(2) NOT NULL default '-1' COMMENT '角色等级',
  `user_game_amount` decimal(10,2) unsigned NOT NULL default '0.00' COMMENT '本服充值金额',
  `user_game_online` INT(11) UNSIGNED DEFAULT '0' NOT NULL COMMENT '在线时长秒',
  `user_active_time` int(10) unsigned NOT NULL default '0' COMMENT '本服激活时间',
  `user_first_pay_time` int(10) unsigned NOT NULL default '0' COMMENT '首次充值时间',
  `user_last_pay_time` int(10) unsigned NOT NULL default '0' COMMENT '最后一次充值时间',
  `user_last_login` int(10) unsigned NOT NULL default '0' COMMENT '最后一次登录时间',
  `user_login_ip` char(15) NOT NULL COMMENT '最后一次登录IP',
  `country` char(3) NOT NULL COMMENT '所属国家', 
  `user_login_times` int(4) unsigned NOT NULL default '1' COMMENT '登录次数',
  `user_login_1` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '激活当天登录次数',
  `user_login_3` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '三天登录天数',
  `user_login_7` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '七天登录天数',
  `user_login_14` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '14天登录天数',
  `user_login_days` tinyint(1) unsigned DEFAULT '1' NOT NULL COMMENT '连续登录天数',
  PRIMARY KEY  (`s_uid`),
  KEY `user_code` (`user_code`),
  KEY `user_id` (`user_id`),
  KEY `active_time` (`user_active_time`),
  KEY `last_login` (`user_last_login`),
  KEY `user_add_date` (`user_add_date`),
  KEY `unions` (`user_channel`,`user_from`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC";